package org.jeecg.modules.fw.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.fw.entity.FwRoomLock;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.jeecg.modules.fw.vo.FwRoomLockVo;

/**
 * @Description: fw_room_lock
 * @Author: jeecg-boot
 * @Date:   2023-04-17
 * @Version: V1.0
 */
public interface FwRoomLockMapper extends BaseMapper<FwRoomLock> {

    @Select("select frl.*,cr.layout_id,crl.name as layout_name,cr.name as room_name from fw_room_lock frl  " +
            "inner join ces_rooms cr on cr.id = frl.room_id "+
            "inner join ces_room_layout crl on crl.id = cr.layout_id ")
    List<FwRoomLockVo> detailList();
}
